IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'SagaSummarysGet')
	BEGIN
		DROP  Procedure  SagaSummarysGet
	END

GO

CREATE Procedure SagaSummarysGet
AS
SELECT 
		s.SagaID,
		s.Name,
		s.TagLine,
		s.Header,
		s.FormationStory,
		DATENAME(month, CONVERT(DATETIME, CONVERT(nvarchar,FoundedMonth) + '/1/2000') ) + ' ' + CONVERT(nvarchar, FoundedYear) + ' A.D.' as FoundedDate
	FROM Saga s
	
	
GO 